Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	20
Number of observations	913599
Missing cells	43008
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	174.3 MiB
Average record size in memory	200.0 B

Variable types

Numeric	14
DateTime	3
Categorical	3

Alerts

`Breadth` is highly overall correlated with `Draught` and 1 other fields	High correlation
`COG` is highly overall correlated with `TH`	High correlation
`Destination` is highly overall correlated with `EndLatitude` and 4 other fields	High correlation
`Draught` is highly overall correlated with `Breadth` and 1 other fields	High correlation
`EndLatitude` is highly overall correlated with `Destination` and 7 other fields	High correlation
`EndLongitude` is highly overall correlated with `Destination` and 7 other fields	High correlation
`EndPort` is highly overall correlated with `Destination` and 7 other fields	High correlation
`Latitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`Length` is highly overall correlated with `Breadth` and 1 other fields	High correlation
`Longitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLatitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLongitude` is highly overall correlated with `Destination` and 7 other fields	High correlation
`StartPort` is highly overall correlated with `Destination` and 7 other fields	High correlation
`TH` is highly overall correlated with `COG`	High correlation
`Destination` is highly imbalanced (55.3%)	Imbalance
`Length` has 10070 (1.1%) missing values	Missing
`Breadth` has 10127 (1.1%) missing values	Missing
`Draught` has 16303 (1.8%) missing values	Missing

Reproduction

Analysis started	2025-06-06 00:26:37.814760
Analysis finished	2025-06-06 00:27:20.027631
Duration	42.21 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

TripID
Real number (ℝ)

Distinct	1126
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1125612.4

Minimum	5944
Maximum	2278147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	5944
5-th percentile	55365
Q1	473272
median	1170717
Q3	1669988
95-th percentile	2160044
Maximum	2278147
Range	2272203
Interquartile range (IQR)	1196716

Descriptive statistics

Standard deviation	673813.44
Coefficient of variation (CV)	0.59861943
Kurtosis	-1.2739594
Mean	1125612.4
Median Absolute Deviation (MAD)	546619
Skewness	-0.039518375
Sum	1.0283583 × 10¹²
Variance	4.5402456 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2183472	2609	0.3%
1669988	2362	0.3%
265994	2085	0.2%
1778056	2068	0.2%
2201111	2059	0.2%
1993462	2053	0.2%
1019076	2036	0.2%
2183480	2026	0.2%
624032	1994	0.2%
1677413	1989	0.2%
Other values (1116)	892318	97.7%

Value	Count	Frequency (%)
5944	1237	0.1%
10257	577	0.1%
19002	41	< 0.1%
19585	1646	0.2%
23834	1241	0.1%
24805	595	0.1%
25124	659	0.1%
28257	1280	0.1%
29139	1247	0.1%
29152	1296	0.1%

Value	Count	Frequency (%)
2278147	518	0.1%
2278140	588	0.1%
2278125	528	0.1%
2278114	574	0.1%
2278113	574	0.1%
2278085	522	0.1%
2278084	522	0.1%
2278083	522	0.1%
2278070	494	0.1%
2278069	494	0.1%

StartLatitude
Real number (ℝ)

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.033009

Minimum	53.33
Maximum	54.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.52
Q1	53.58
median	54.36
Q3	54.36
95-th percentile	54.36
Maximum	54.54
Range	1.21
Interquartile range (IQR)	0.78

Descriptive statistics

Standard deviation	0.39140826
Coefficient of variation (CV)	0.0072438731
Kurtosis	-1.8378418
Mean	54.033009
Median Absolute Deviation (MAD)	0
Skewness	-0.36154275
Sum	49364503
Variance	0.15320042
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
54.36	525482	57.5%
53.58	168718	18.5%
53.59	56719	6.2%
53.51	34008	3.7%
53.57	26593	2.9%
53.53	23437	2.6%
53.6	21983	2.4%
53.52	10380	1.1%
53.55	5686	0.6%
53.56	5650	0.6%
Other values (18)	34943	3.8%

Value	Count	Frequency (%)
53.33	3169	0.3%
53.34	2535	0.3%
53.5	1285	0.1%
53.51	34008	3.7%
53.52	10380	1.1%
53.53	23437	2.6%
53.54	1288	0.1%
53.55	5686	0.6%
53.56	5650	0.6%
53.57	26593	2.9%

Value	Count	Frequency (%)
54.54	3667	0.4%
54.49	552	0.1%
54.37	1257	0.1%
54.36	525482	57.5%
54.33	3161	0.3%
54.31	1158	0.1%
53.75	976	0.1%
53.74	530	0.1%
53.67	2150	0.2%
53.66	411	< 0.1%

StartLongitude
Real number (ℝ)

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4652222

Minimum	8.14
Maximum	10.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	8.14
5-th percentile	8.5
Q1	8.52
median	10.14
Q3	10.14
95-th percentile	10.14
Maximum	10.34
Range	2.2
Interquartile range (IQR)	1.62

Descriptive statistics

Standard deviation	0.80563974
Coefficient of variation (CV)	0.085115776
Kurtosis	-1.8490833
Mean	9.4652222
Median Absolute Deviation (MAD)	0
Skewness	-0.36018461
Sum	8647417.6
Variance	0.64905539
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
10.14	498287	54.5%
8.52	160444	17.6%
8.53	78601	8.6%
8.51	36432	4.0%
8.57	31343	3.4%
10.13	24011	2.6%
8.54	15226	1.7%
8.5	11982	1.3%
8.15	10964	1.2%
8.49	9062	1.0%
Other values (24)	37247	4.1%

Value	Count	Frequency (%)
8.14	485	0.1%
8.15	10964	1.2%
8.16	1297	0.1%
8.19	976	0.1%
8.22	530	0.1%
8.36	1078	0.1%
8.37	1072	0.1%
8.38	411	< 0.1%
8.39	984	0.1%
8.4	523	0.1%

Value	Count	Frequency (%)
10.34	552	0.1%
10.29	3667	0.4%
10.18	3188	0.3%
10.17	2933	0.3%
10.16	1485	0.2%
10.15	1154	0.1%
10.14	498287	54.5%
10.13	24011	2.6%
8.57	31343	3.4%
8.56	3146	0.3%

StartTime
Date

Distinct	953
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 06:03:00+00:00
Maximum	2017-05-26 19:44:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

EndLatitude
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.084079

Minimum	53.47
Maximum	54.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.47
5-th percentile	53.5
Q1	53.53
median	54.38
Q3	54.53
95-th percentile	54.54
Maximum	54.64
Range	1.17
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.47536514
Coefficient of variation (CV)	0.008789373
Kurtosis	-1.8529125
Mean	54.084079
Median Absolute Deviation (MAD)	0.16
Skewness	-0.3132826
Sum	49411160
Variance	0.22597202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
54.54	217507	23.8%
53.53	194398	21.3%
53.5	87533	9.6%
54.38	85200	9.3%
54.52	54381	6.0%
54.53	40517	4.4%
53.54	37790	4.1%
54.44	33365	3.7%
53.52	31820	3.5%
54.43	24028	2.6%
Other values (19)	107060	11.7%

Value	Count	Frequency (%)
53.47	1290	0.1%
53.48	677	0.1%
53.49	9439	1.0%
53.5	87533	9.6%
53.51	10829	1.2%
53.52	31820	3.5%
53.53	194398	21.3%
53.54	37790	4.1%
53.56	678	0.1%
53.61	2018	0.2%

Value	Count	Frequency (%)
54.64	1646	0.2%
54.59	740	0.1%
54.54	217507	23.8%
54.53	40517	4.4%
54.52	54381	6.0%
54.51	5163	0.6%
54.5	522	0.1%
54.47	1280	0.1%
54.46	7688	0.8%
54.45	8797	1.0%

EndLongitude
Real number (ℝ)

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.99502

Minimum	9.5
Maximum	18.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	9.5
5-th percentile	9.9
Q1	9.93
median	18.5
Q3	18.6
95-th percentile	18.71
Maximum	18.92
Range	9.42
Interquartile range (IQR)	8.67

Descriptive statistics

Standard deviation	4.2753283
Coefficient of variation (CV)	0.28511654
Kurtosis	-1.8773544
Mean	14.99502
Median Absolute Deviation (MAD)	0.17
Skewness	-0.34813669
Sum	13699435
Variance	18.278432
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
18.51	115647	12.7%
18.5	101860	11.1%
9.91	100740	11.0%
9.93	76722	8.4%
9.9	60305	6.6%
18.65	45248	5.0%
9.95	44441	4.9%
18.66	44309	4.8%
18.67	37755	4.1%
9.82	27616	3.0%
Other values (37)	258956	28.3%

Value	Count	Frequency (%)
9.5	1189	0.1%
9.51	661	0.1%
9.54	1196	0.1%
9.55	178	< 0.1%
9.56	644	0.1%
9.73	678	0.1%
9.82	27616	3.0%
9.83	6963	0.8%
9.88	1221	0.1%
9.9	60305	6.6%

Value	Count	Frequency (%)
18.92	1646	0.2%
18.88	740	0.1%
18.83	7385	0.8%
18.82	11996	1.3%
18.81	4884	0.5%
18.75	1501	0.2%
18.72	3774	0.4%
18.71	27107	3.0%
18.7	7897	0.9%
18.68	3368	0.4%

EndTime
Date

Distinct	943
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 14:36:00+00:00
Maximum	2017-05-27 22:11:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

StartPort
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	892.5 KiB

KIEL	535277
BREMERHAVEN	378322

Length

Max length	11
Median length	4
Mean length	6.898705
Min length	4

Characters and Unicode

Total characters	6302650
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BREMERHAVEN
2nd row	BREMERHAVEN
3rd row	BREMERHAVEN
4th row	BREMERHAVEN
5th row	BREMERHAVEN

Common Values

Value	Count	Frequency (%)
KIEL	535277	58.6%
BREMERHAVEN	378322	41.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kiel	535277	58.6%
bremerhaven	378322	41.4%

Most occurring characters

Value	Count	Frequency (%)
E	1670243	26.5%
R	756644	12.0%
K	535277	8.5%
I	535277	8.5%
L	535277	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6302650	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	1670243	26.5%
R	756644	12.0%
K	535277	8.5%
I	535277	8.5%
L	535277	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6302650	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	1670243	26.5%
R	756644	12.0%
K	535277	8.5%
I	535277	8.5%
L	535277	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6302650	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	1670243	26.5%
R	756644	12.0%
K	535277	8.5%
I	535277	8.5%
L	535277	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

EndPort
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	892.5 KiB

GDYNIA	535277
HAMBURG	378322

Length

Max length	7
Median length	6
Mean length	6.4141007
Min length	6

Characters and Unicode

Total characters	5859916
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Common Values

Value	Count	Frequency (%)
GDYNIA	535277	58.6%
HAMBURG	378322	41.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gdynia	535277	58.6%
hamburg	378322	41.4%

Most occurring characters

Value	Count	Frequency (%)
G	913599	15.6%
A	913599	15.6%
D	535277	9.1%
Y	535277	9.1%
N	535277	9.1%
I	535277	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5859916	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	913599	15.6%
A	913599	15.6%
D	535277	9.1%
Y	535277	9.1%
N	535277	9.1%
I	535277	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5859916	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	913599	15.6%
A	913599	15.6%
D	535277	9.1%
Y	535277	9.1%
N	535277	9.1%
I	535277	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5859916	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	913599	15.6%
A	913599	15.6%
D	535277	9.1%
Y	535277	9.1%
N	535277	9.1%
I	535277	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

time
Date

Distinct	414193
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 06:03:00+00:00
Maximum	2017-05-27 22:11:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

shiptype
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	6440
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%
Mean	72.271913

Minimum	69
Maximum	89
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	69
5-th percentile	70
Q1	70
median	71
Q3	71
95-th percentile	80
Maximum	89
Range	20
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.5290157
Coefficient of variation (CV)	0.048829698
Kurtosis	0.88312527
Mean	72.271913
Median Absolute Deviation (MAD)	1
Skewness	1.5964718
Sum	65562116
Variance	12.453952
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
71	406083	44.4%
70	311250	34.1%
79	122970	13.5%
81	34528	3.8%
72	12776	1.4%
80	10865	1.2%
73	3625	0.4%
74	3334	0.4%
69	1144	0.1%
89	584	0.1%
(Missing)	6440	0.7%

Value	Count	Frequency (%)
69	1144	0.1%
70	311250	34.1%
71	406083	44.4%
72	12776	1.4%
73	3625	0.4%
74	3334	0.4%
79	122970	13.5%
80	10865	1.2%
81	34528	3.8%
89	584	0.1%

Value	Count	Frequency (%)
89	584	0.1%
81	34528	3.8%
80	10865	1.2%
79	122970	13.5%
74	3334	0.4%
73	3625	0.4%
72	12776	1.4%
71	406083	44.4%
70	311250	34.1%
69	1144	0.1%

Length
Real number (ℝ)

High correlation Missing

Distinct	98
Distinct (%)	< 0.1%
Missing	10070
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	128.53889

Minimum	45
Maximum	399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	45
5-th percentile	74
Q1	89
median	134
Q3	154
95-th percentile	171
Maximum	399
Range	354
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	42.623176
Coefficient of variation (CV)	0.33159751
Kurtosis	6.7830954
Mean	128.53889
Median Absolute Deviation (MAD)	30
Skewness	1.5032217
Sum	1.1613862 × 10⁸
Variance	1816.7352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
151	88721	9.7%
134	77476	8.5%
88	60876	6.7%
155	58691	6.4%
125	47042	5.1%
168	40460	4.4%
82	34232	3.7%
79	34121	3.7%
154	32693	3.6%
68	31700	3.5%
Other values (88)	397517	43.5%

Value	Count	Frequency (%)
45	1760	0.2%
65	1648	0.2%
66	1509	0.2%
68	31700	3.5%
70	5412	0.6%
74	9892	1.1%
75	10068	1.1%
79	34121	3.7%
80	1606	0.2%
81	8616	0.9%

Value	Count	Frequency (%)
399	1716	0.2%
397	1153	0.1%
396	660	0.1%
300	1142	0.1%
299	537	0.1%
295	1252	0.1%
294	2171	0.2%
293	1214	0.1%
277	1629	0.2%
275	3297	0.4%

Breadth
Real number (ℝ)

High correlation Missing

Distinct	34
Distinct (%)	< 0.1%
Missing	10127
Missing (%)	1.1%
Infinite	0
Infinite (%)	0.0%
Mean	20.288646

Minimum	8
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	8
5-th percentile	12
Q1	13
median	22
Q3	24
95-th percentile	27
Maximum	60
Range	52
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.1808664
Coefficient of variation (CV)	0.30464656
Kurtosis	5.16364
Mean	20.288646
Median Absolute Deviation (MAD)	3
Skewness	0.93156625
Sum	18330224
Variance	38.20311
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
22	134856	14.8%
23	110567	12.1%
12	105533	11.6%
24	100922	11.0%
13	95408	10.4%
25	67083	7.3%
26	49595	5.4%
18	42349	4.6%
19	38460	4.2%
27	26307	2.9%
Other values (24)	132392	14.5%

Value	Count	Frequency (%)
8	1760	0.2%
9	637	0.1%
10	3499	0.4%
11	23892	2.6%
12	105533	11.6%
13	95408	10.4%
14	13141	1.4%
15	14020	1.5%
16	12775	1.4%
17	1662	0.2%

Value	Count	Frequency (%)
60	1716	0.2%
59	660	0.1%
56	1153	0.1%
48	1142	0.1%
42	1071	0.1%
40	3919	0.4%
36	652	0.1%
35	564	0.1%
33	681	0.1%
32	13768	1.5%

Draught
Real number (ℝ)

High correlation Missing

Distinct	237
Distinct (%)	< 0.1%
Missing	16303
Missing (%)	1.8%
Infinite	0
Infinite (%)	0.0%
Mean	6.4696078

Minimum	0.1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0.1
5-th percentile	2.8
Q1	4.59
median	7.2
Q3	8.3
95-th percentile	9.3
Maximum	14
Range	13.9
Interquartile range (IQR)	3.71

Descriptive statistics

Standard deviation	2.1897036
Coefficient of variation (CV)	0.33846003
Kurtosis	-1.0528092
Mean	6.4696078
Median Absolute Deviation (MAD)	1.6
Skewness	-0.29017902
Sum	5805153.2
Variance	4.7948019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.8	46318	5.1%
3.2	31677	3.5%
8.3	24085	2.6%
7.9	17477	1.9%
7.7	17073	1.9%
8.4	15522	1.7%
8.1	15030	1.6%
8	14613	1.6%
3.8	14105	1.5%
9.2	14024	1.5%
Other values (227)	687372	75.2%
(Missing)	16303	1.8%

Value	Count	Frequency (%)
0.1	637	0.1%
1.93	1771	0.2%
2.3	1607	0.2%
2.4	1828	0.2%
2.5	1373	0.2%
2.6	7279	0.8%
2.63	41	< 0.1%
2.7	1782	0.2%
2.8	46318	5.1%
2.9	471	0.1%

Value	Count	Frequency (%)
14	15	< 0.1%
13.23	544	0.1%
11.7	645	0.1%
11.54	1071	0.1%
11.45	551	0.1%
11.4	1223	0.1%
11.24	691	0.1%
11.1	627	0.1%
11	368	< 0.1%
10.98	211	< 0.1%

Latitude
Real number (ℝ)

High correlation

Distinct	273
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.287473

Minimum	53.33
Maximum	56.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.56
Q1	53.85
median	54.47
Q3	54.65
95-th percentile	54.89
Maximum	56.34
Range	3.01
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.45826823
Coefficient of variation (CV)	0.0084415096
Kurtosis	-1.0504922
Mean	54.287473
Median Absolute Deviation (MAD)	0.34
Skewness	-0.13313054
Sum	49596981
Variance	0.21000977
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.87	28797	3.2%
54.53	23462	2.6%
54.41	20333	2.2%
53.84	20044	2.2%
53.98	19631	2.1%
54.56	17212	1.9%
53.54	17009	1.9%
53.86	16700	1.8%
54.74	16683	1.8%
54.57	16667	1.8%
Other values (263)	717061	78.5%

Value	Count	Frequency (%)
53.33	13	< 0.1%
53.34	40	< 0.1%
53.35	29	< 0.1%
53.36	26	< 0.1%
53.37	25	< 0.1%
53.38	27	< 0.1%
53.39	26	< 0.1%
53.4	23	< 0.1%
53.41	24	< 0.1%
53.42	26	< 0.1%

Value	Count	Frequency (%)
56.34	2	< 0.1%
56.33	4	< 0.1%
56.32	4	< 0.1%
56.31	3	< 0.1%
56.3	3	< 0.1%
56.29	12	< 0.1%
56.28	8	< 0.1%
56.27	5	< 0.1%
56.26	5	< 0.1%
56.25	6	< 0.1%

Longitude
Real number (ℝ)

High correlation

Distinct	1285
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.995726

Minimum	2.32
Maximum	20.66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	2.32
5-th percentile	8.08
Q1	9.03
median	11.08
Q3	14.12
95-th percentile	18.8
Maximum	20.66
Range	18.34
Interquartile range (IQR)	5.09

Descriptive statistics

Standard deviation	3.5082469
Coefficient of variation (CV)	0.29245807
Kurtosis	-0.653744
Mean	11.995726
Median Absolute Deviation (MAD)	2.4
Skewness	0.74748595
Sum	10959283
Variance	12.307797
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.51	4757	0.5%
8.52	4514	0.5%
8.12	4441	0.5%
9.93	4405	0.5%
8.11	4178	0.5%
9.9	4113	0.5%
9.5	4022	0.4%
8.51	3619	0.4%
8.15	3189	0.3%
9.39	3178	0.3%
Other values (1275)	873183	95.6%

Value	Count	Frequency (%)
2.32	1	< 0.1%
7.71	2	< 0.1%
7.72	45	< 0.1%
7.73	102	< 0.1%
7.74	99	< 0.1%
7.75	108	< 0.1%
7.76	83	< 0.1%
7.77	83	< 0.1%
7.78	81	< 0.1%
7.79	78	< 0.1%

Value	Count	Frequency (%)
20.66	1	< 0.1%
20.65	3	< 0.1%
20.64	2	< 0.1%
20.63	2	< 0.1%
20.62	3	< 0.1%
20.61	3	< 0.1%
20.6	2	< 0.1%
20.59	3	< 0.1%
20.58	3	< 0.1%
20.57	3	< 0.1%

SOG
Real number (ℝ)

Distinct	227
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.044566

Minimum	0.2
Maximum	73.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0.2
5-th percentile	6.5
Q1	9.8
median	11.9
Q3	14.6
95-th percentile	17.5
Maximum	73.6
Range	73.4
Interquartile range (IQR)	4.8

Descriptive statistics

Standard deviation	3.5403783
Coefficient of variation (CV)	0.29393989
Kurtosis	0.7935745
Mean	12.044566
Median Absolute Deviation (MAD)	2.4
Skewness	-0.41159347
Sum	11003903
Variance	12.534279
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.4	13193	1.4%
10.5	13133	1.4%
10.7	12783	1.4%
10.6	12764	1.4%
10.3	12519	1.4%
11	11598	1.3%
11.6	11505	1.3%
10.9	11485	1.3%
10.2	11480	1.3%
11.7	11383	1.2%
Other values (217)	791756	86.7%

Value	Count	Frequency (%)
0.2	442	< 0.1%
0.3	1617	0.2%
0.4	1337	0.1%
0.5	1054	0.1%
0.6	958	0.1%
0.7	814	0.1%
0.8	907	0.1%
0.9	843	0.1%
1	771	0.1%
1.1	738	0.1%

Value	Count	Frequency (%)
73.6	2	< 0.1%
51.2	1	< 0.1%
22.6	1	< 0.1%
22.5	1	< 0.1%
22.4	2	< 0.1%
22.3	1	< 0.1%
22.2	4	< 0.1%
22.1	4	< 0.1%
22	6	< 0.1%
21.9	5	< 0.1%

COG
Real number (ℝ)

High correlation

Distinct	3601
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	124.97896

Minimum	0
Maximum	360
Zeros	192
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	44
Q1	81.8
median	99.1
Q3	134
95-th percentile	312
Maximum	360
Range	360
Interquartile range (IQR)	52.2

Descriptive statistics

Standard deviation	76.465662
Coefficient of variation (CV)	0.61182827
Kurtosis	1.3315296
Mean	124.97896
Median Absolute Deviation (MAD)	21.5
Skewness	1.4931655
Sum	1.1418066 × 10⁸
Variance	5846.9975
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	7475	0.8%
90	7334	0.8%
82	6782	0.7%
86	5624	0.6%
89	5526	0.6%
85	5337	0.6%
83	5150	0.6%
87	4993	0.5%
88	4950	0.5%
84	4679	0.5%
Other values (3591)	855749	93.7%

Value	Count	Frequency (%)
0	192	< 0.1%
0.1	290	< 0.1%
0.2	26	< 0.1%
0.3	26	< 0.1%
0.4	19	< 0.1%
0.5	37	< 0.1%
0.6	31	< 0.1%
0.7	29	< 0.1%
0.8	23	< 0.1%
0.9	44	< 0.1%

Value	Count	Frequency (%)
360	12	< 0.1%
359.9	43	< 0.1%
359.8	29	< 0.1%
359.7	16	< 0.1%
359.6	28	< 0.1%
359.5	28	< 0.1%
359.4	20	< 0.1%
359.3	31	< 0.1%
359.2	22	< 0.1%
359.1	40	< 0.1%

TH
Real number (ℝ)

High correlation

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	130.71848

Minimum	0
Maximum	511
Zeros	565
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	45
Q1	82
median	99
Q3	136
95-th percentile	320
Maximum	511
Range	511
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	89.243589
Coefficient of variation (CV)	0.68271595
Kurtosis	3.8355682
Mean	130.71848
Median Absolute Deviation (MAD)	22
Skewness	1.9151744
Sum	1.1942427 × 10⁸
Variance	7964.4182
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	22874	2.5%
81	21301	2.3%
83	20883	2.3%
90	20022	2.2%
84	18941	2.1%
85	18885	2.1%
89	16462	1.8%
86	16055	1.8%
88	15375	1.7%
80	15244	1.7%
Other values (351)	727557	79.6%

Value	Count	Frequency (%)
0	565	0.1%
1	410	< 0.1%
2	349	< 0.1%
3	363	< 0.1%
4	262	< 0.1%
5	277	< 0.1%
6	271	< 0.1%
7	314	< 0.1%
8	282	< 0.1%
9	205	< 0.1%

Value	Count	Frequency (%)
511	12963	1.4%
359	399	< 0.1%
358	412	< 0.1%
357	337	< 0.1%
356	395	< 0.1%
355	465	0.1%
354	408	< 0.1%
353	295	< 0.1%
352	265	< 0.1%
351	223	< 0.1%

Destination
Categorical

High correlation Imbalance

Distinct	16
Distinct (%)	< 0.1%
Missing	68
Missing (%)	< 0.1%
Memory size	54.0 MiB

DEHAM	375027
PLGDY	291378
PLGDN	211839
LTKLJ	23353
DESTA	3787
Other values (11)	8147

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	4567655
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DEHAM
2nd row	DEHAM
3rd row	DEHAM
4th row	DEHAM
5th row	DEHAM

Common Values

Value	Count	Frequency (%)
DEHAM	375027	41.0%
PLGDY	291378	31.9%
PLGDN	211839	23.2%
LTKLJ	23353	2.6%
DESTA	3787	0.4%
DEKEL	3267	0.4%
DEBRV	2439	0.3%
RUKGD	1337	0.1%
SENOK	540	0.1%
SEHAD	334	< 0.1%
Other values (6)	230	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
deham	375027	41.1%
plgdy	291378	31.9%
plgdn	211839	23.2%
ltklj	23353	2.6%
desta	3787	0.4%
dekel	3267	0.4%
debrv	2439	0.3%
rukgd	1337	0.1%
senok	540	0.1%
sehad	334	< 0.1%
Other values (6)	230	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
D	889530	19.5%
L	553296	12.1%
G	504554	11.0%
P	503323	11.0%
E	388827	8.5%
A	379148	8.3%
H	375363	8.2%
M	375027	8.2%
Y	291378	6.4%
N	212379	4.6%
Other values (12)	94830	2.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	4567655	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
D	889530	19.5%
L	553296	12.1%
G	504554	11.0%
P	503323	11.0%
E	388827	8.5%
A	379148	8.3%
H	375363	8.2%
M	375027	8.2%
Y	291378	6.4%
N	212379	4.6%
Other values (12)	94830	2.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	4567655	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
D	889530	19.5%
L	553296	12.1%
G	504554	11.0%
P	503323	11.0%
E	388827	8.5%
A	379148	8.3%
H	375363	8.2%
M	375027	8.2%
Y	291378	6.4%
N	212379	4.6%
Other values (12)	94830	2.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	4567655	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
D	889530	19.5%
L	553296	12.1%
G	504554	11.0%
P	503323	11.0%
E	388827	8.5%
A	379148	8.3%
H	375363	8.2%
M	375027	8.2%
Y	291378	6.4%
N	212379	4.6%
Other values (12)	94830	2.1%

	Breadth	COG	Destination	Draught	EndLatitude	EndLongitude	EndPort	Latitude	Length	Longitude	SOG	StartLatitude	StartLongitude	StartPort	TH	TripID	shiptype
Breadth	1.000	0.034	0.198	0.902	0.079	-0.272	0.407	-0.087	0.937	-0.097	0.433	-0.037	-0.183	0.407	0.020	-0.021	0.300
COG	0.034	1.000	0.167	0.001	-0.290	-0.290	0.460	-0.344	-0.005	-0.123	0.001	-0.323	-0.307	0.460	0.937	0.007	0.034
Destination	0.198	0.167	1.000	0.183	0.698	0.995	0.995	0.354	0.232	0.327	0.126	0.448	0.704	0.995	0.155	0.160	0.170
Draught	0.902	0.001	0.183	1.000	0.129	-0.171	0.261	-0.010	0.914	-0.019	0.425	0.078	-0.095	0.261	-0.006	0.021	0.333
EndLatitude	0.079	-0.290	0.698	0.129	1.000	0.525	1.000	0.751	0.152	0.736	-0.020	0.815	0.798	1.000	-0.283	-0.025	-0.100
EndLongitude	-0.272	-0.290	0.995	-0.171	0.525	1.000	1.000	0.719	-0.158	0.731	-0.268	0.813	0.817	1.000	-0.262	0.009	-0.038
EndPort	0.407	0.460	0.995	0.261	1.000	1.000	1.000	1.000	0.399	0.919	0.101	1.000	1.000	1.000	0.397	0.263	0.229
Latitude	-0.087	-0.344	0.354	-0.010	0.751	0.719	1.000	1.000	0.005	0.800	-0.043	0.813	0.797	1.000	-0.322	-0.013	-0.074
Length	0.937	-0.005	0.232	0.914	0.152	-0.158	0.399	0.005	1.000	-0.001	0.428	0.099	-0.101	0.399	-0.015	-0.051	0.273
Longitude	-0.097	-0.123	0.327	-0.019	0.736	0.731	0.919	0.800	-0.001	1.000	-0.211	0.814	0.798	0.919	-0.111	-0.013	-0.080
SOG	0.433	0.001	0.126	0.425	-0.020	-0.268	0.101	-0.043	0.428	-0.211	1.000	-0.113	-0.191	0.101	-0.025	-0.058	0.190
StartLatitude	-0.037	-0.323	0.448	0.078	0.815	0.813	1.000	0.813	0.099	0.814	-0.113	1.000	0.842	1.000	-0.304	-0.012	-0.071
StartLongitude	-0.183	-0.307	0.704	-0.095	0.798	0.817	1.000	0.797	-0.101	0.798	-0.191	0.842	1.000	1.000	-0.286	-0.004	-0.089
StartPort	0.407	0.460	0.995	0.261	1.000	1.000	1.000	1.000	0.399	0.919	0.101	1.000	1.000	1.000	0.397	0.263	0.229
TH	0.020	0.937	0.155	-0.006	-0.283	-0.262	0.397	-0.322	-0.015	-0.111	-0.025	-0.304	-0.286	0.397	1.000	0.007	0.033
TripID	-0.021	0.007	0.160	0.021	-0.025	0.009	0.263	-0.013	-0.051	-0.013	-0.058	-0.012	-0.004	0.263	0.007	1.000	0.148
shiptype	0.300	0.034	0.170	0.333	-0.100	-0.038	0.229	-0.074	0.273	-0.080	0.190	-0.071	-0.089	0.229	0.033	0.148	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination
0	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:07:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	0.7	331.2	143	DEHAM
1	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:10:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	1.6	315.3	117	DEHAM
2	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:10:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	2.8	322.6	100	DEHAM
3	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:12:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	2.8	286.3	74	DEHAM
4	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:16:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	4.3	333.1	333	DEHAM
5	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:17:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	5.2	334.0	333	DEHAM
6	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:18:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	5.7	333.0	333	DEHAM
7	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:19:00+00:00	71.0	277.0	42.0	11.54	53.57	8.52	6.3	333.0	333	DEHAM
8	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:20:00+00:00	71.0	277.0	42.0	11.54	53.58	8.52	6.8	333.0	333	DEHAM
9	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:21:00+00:00	71.0	277.0	42.0	11.54	53.58	8.52	7.1	332.1	333	DEHAM

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination
913589	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:02:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	222.0	215	PLGDN
913590	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:01:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	221.6	215	PLGDN
913591	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:00:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	221.5	215	PLGDN
913592	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:59:00+00:00	70.0	89.0	13.0	4.0	54.50	18.75	7.2	221.2	215	PLGDN
913593	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:58:00+00:00	70.0	89.0	13.0	4.0	54.50	18.75	7.2	220.8	215	PLGDN
913594	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:57:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	221.0	215	PLGDN
913595	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:56:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	221.9	215	PLGDN
913596	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:55:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	222.1	215	PLGDN
913597	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:54:00+00:00	70.0	89.0	13.0	4.0	54.51	18.76	7.2	221.2	215	PLGDN
913598	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:53:00+00:00	70.0	89.0	13.0	4.0	54.51	18.76	7.2	221.0	214	PLGDN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample